Data management

We need to convert the table to a vector format (Spread → Manipulate → Convert…) and rename the columns as milk1, milk2, milk3, milk4, milk5 as shown below.

We now repeat the same steps but with the variable conc instead of milk.

Having done this, and then reselected the first spreadsheet of means for milk yield, we can add the data for conc1to conc5 to the existing columns of means for milk by simply clicking Spread → Add →Data in GenStat….

To add the overall averages for milk yield and concentrate we need to repeat the above steps but with just the factor cow in the 'Groups' box. We then save the complete file having converted all fields to 2 decimal places in CS6Data3.